Tabela ChemotherapyInvoice

Definicja tabeli ChemotherapyInvoice

Name

ChemotherapyInvoice

Code

ChemotherapyInvoice

Comment

Informacje na temat faktury zakupowej i pozycji w ramach której zosta zakupiony lek


Lista kolumn tabeli ChemotherapyInvoice

Name

Code

ChemotherapyInvoiceID

ChemotherapyInvoiceID

ChemotherapyID

ChemotherapyID

TaxPayerID

TaxPayerID

InvoiceNo

InvoiceNo

PositionInInvoice

PositionInInvoice

Active

Active

DrugAmount

DrugAmount

PerfDT

PerfDT


Kolumna ChemotherapyInvoiceID tabeli ChemotherapyInvoice

Definicja kolumny ChemotherapyInvoiceID tabeli ChemotherapyInvoice

Name

ChemotherapyInvoiceID

Code

ChemotherapyInvoiceID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ChemotherapyID tabeli ChemotherapyInvoice

Definicja kolumny ChemotherapyID tabeli ChemotherapyInvoice

Name

ChemotherapyID

Code

ChemotherapyID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna TaxPayerID tabeli ChemotherapyInvoice

Definicja kolumny TaxPayerID tabeli ChemotherapyInvoice

Name

TaxPayerID

Code

TaxPayerID

Data Type

VARCHAR2(13)

Mandatory

No

Comment

nip sprzedajacego


Kolumna InvoiceNo tabeli ChemotherapyInvoice

Definicja kolumny InvoiceNo tabeli ChemotherapyInvoice

Name

InvoiceNo

Code

InvoiceNo

Data Type

VARCHAR2(25)

Mandatory

No

Comment

numer faktury


Kolumna PositionInInvoice tabeli ChemotherapyInvoice

Definicja kolumny PositionInInvoice tabeli ChemotherapyInvoice

Name

PositionInInvoice

Code

PositionInInvoice

Data Type

NUMBER(5)

Mandatory

No

Comment

numer pozycji na fakturze


Kolumna Active tabeli ChemotherapyInvoice

Definicja kolumny Active tabeli ChemotherapyInvoice

Name

Active

Code

Active

Data Type

NUMBER(3)

Mandatory

No

Comment

Czy dany wpis jest aktywny


Kolumna DrugAmount tabeli ChemotherapyInvoice

Definicja kolumny DrugAmount tabeli ChemotherapyInvoice

Name

DrugAmount

Code

DrugAmount

Data Type

NUMBER(16,4)

Mandatory

No

Comment

 


Kolumna PerfDT tabeli ChemotherapyInvoice

Definicja kolumny PerfDT tabeli ChemotherapyInvoice

Name

PerfDT

Code

PerfDT

Data Type

DATE

Mandatory

No

Comment

Data wystawienia faktury która jest wymagana prawnie od 1 maja 2015 roku w komunikacie SWX


Lista kluczy tabeli ChemotherapyInvoice

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli ChemotherapyInvoice

Definicja klucza Identifier_1 tabeli ChemotherapyInvoice

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment